 <?php
   // configuration
    $dbtype     = "mysql";
    $dbhost     = "localhost";
    $dbname     = "OSPMS";
    $dbuser     = "ospms";
    $dbpass     = "ospms";
     
    // database connection
#    $conn = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass);
     
    $sql = "INSERT INTO user_uploaded_files (user_id, folder_id, study_id, file_name, file_type, file_location ) VALUES (:user_id, :folder_id, :study_id, :file_name, :file_type, :f_location)";

print "sql=$sql\n";

    $q = $conn->prepare($sql);
	$i=1;
	$j='2';
    $q->execute(array(':user_id'=$i,
                      ':fold_id'=>$i,
                      ':study_id'=>$i,
                      ':file_name'=>$j,
                      ':file_type'=>$j,
                      ':f_location'=>$j
		));

?>
